<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 
<title>kingdom4 log</title> 
<style type="text/CSS"> 
<!-- 
.page a:link { 
color: #0000FF; 
text-decoration: none; 
} 
.page a:visited { 
text-decoration: none; 
color: #0000FF; 
} 
.page a:hover { 
text-decoration: none; 
color: #0000FF; 
} 
.page a:active { 
text-decoration: none; 
color: #0000FF; 
} 
.page{color:#0000FF;} 
--> 
</style> 
</head> 
<body> 
<form name="form" action="search.php" method="post">
<input type="text" name="search_text" size="20">
<input type="submit" value="搜索">
</form>
<table width="950" height="103" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC"> 
<tr> 
<th width="50" height="38" bgcolor="#E3E3E3" scope="col">ID</th> 
<th width="50" bgcolor="#E3E3E3" scope="col">gamename</th>
<th width="50" bgcolor="#E3E3E3" scope="col">createdate</th>
<th width="50" bgcolor="#E3E3E3" scope="col">OnlineFightCount</th>
<th width="50" bgcolor="#E3E3E3" scope="col">Cents4999</th>
<th width="50" bgcolor="#E3E3E3" scope="col">Cents999</th>
<th width="50" bgcolor="#E3E3E3" scope="col">Cents9999</th>
<th width="50" bgcolor="#E3E3E3" scope="col">AllCents</th>
<th width="50" bgcolor="#E3E3E3" scope="col">Cents099</th>
<th width="50" bgcolor="#E3E3E3" scope="col">gameTime</th>
<th width="50" bgcolor="#E3E3E3" scope="col">stageMax</th>
<th width="50" bgcolor="#E3E3E3" scope="col">days</th>
<th width="50" bgcolor="#E3E3E3" scope="col">NormalStageFightCount</th>
<th width="50" bgcolor="#E3E3E3" scope="col">Cents1999</th>
<th width="50" bgcolor="#E3E3E3" scope="col">Cents499</th>
<th width="50" bgcolor="#E3E3E3" scope="col">OnlineFightWinCount</th>
<th width="25" bgcolor="#E3E3E3" scope="col">NowtCrystals</th>
<th width="25" bgcolor="#E3E3E3" scope="col">BossStageFightCount</th>
<th width="25" bgcolor="#E3E3E3" scope="col">AlltCrystals</th>
<th width="25" bgcolor="#E3E3E3" scope="col">versionNum</th>
<th width="100" bgcolor="#E3E3E3" scope="col">deviceid</th>
</tr> 
<?php 

   # $mysql_server_name="192.168.0.185"; //数据库服务器名称
   
   # $mysql_username="root"; // 连接数据库用户名
   # $mysql_password="root"; // 连接数据库密码
   # $mysql_database="kingdom4"; // 数据库的名字
 
$link=MySQL_connect('localhost','root','root'); 
mysql_select_db('logs'); 
mysql_query('set names utf-8'); 
var_dump($link);
$Page_size=50; 

$result=mysql_query('select id,gamename,createdate,OnlineFightCount,Cents4999,Cents999,Cents9999,AllCents,Cents099,gameTime,stageMax,days,NormalStageFightCount,Cents1999,Cents499,OnlineFightWinCount,NowtCrystals,BossStageFightCount,AlltCrystals,versionNum,deviceid from logs  order by id desc'); 
var_dump($result);
$count = mysql_num_rows($result); 
$page_count = ceil($count/$Page_size); 

$init=1; 
$page_len=7; 
$max_p=$page_count; 
$pages=$page_count; 

//判断当前页码 
if(empty($_GET['page'])||$_GET['page']<0){ 
$page=1; 
}else { 
$page=$_GET['page']; 
} 

$offset=$Page_size*($page-1); 
$sql="select id,gamename,createdate,OnlineFightCount,Cents4999,Cents999,Cents9999,AllCents,Cents099,gameTime,stageMax,days,NormalStageFightCount,Cents1999,Cents499,OnlineFightWinCount,NowtCrystals,BossStageFightCount,AlltCrystals,versionNum,deviceid from logs  order by id desc limit $offset,$Page_size"; 
$result=mysql_query($sql,$link); 
while ($row=mysql_fetch_array($result)) { 
?> 
<tr> 
<td bgcolor="#E0EEE0" height="25px"><div align="center"> 
<?php echo $row['id'].""?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['gamename']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['createdate']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['OnlineFightCount']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['Cents4999']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['Cents999']?> 
</div></td> 

<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['Cents9999']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['AllCents']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['Cents099']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['gameTime']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['stageMax']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['days']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['NormalStageFightCount']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['Cents1999']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['Cents499']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['OnlineFightWinCount']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['NowtCrystals']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['BossStageFightCount']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['AlltCrystals']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['versionNum']?> 
</div></td> 
<td bgcolor="#E0EEE"><div align="center"> 
<?php echo $row['deviceid']?> 
</div></td> 
</tr> 

<?php 
} 
$page_len = ($page_len%2)?$page_len:$pagelen+1;//页码个数 
$pageoffset = ($page_len-1)/2;//页码个数左右偏移量 

$key='<div class="page">'; 
$key.="<span>$page/$pages</span> "; //第几页,共几页 
if($page!=1){ 
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=1\">第一页</a> "; //第一页 
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=".($page-1)."\">上一页</a>"; //上一页 
}else { 
$key.="第一页 ";//第一页 
$key.="上一页"; //上一页 
} 
if($pages>$page_len){ 
//如果当前页小于等于左偏移 
if($page<=$pageoffset){ 
$init=1; 
$max_p = $page_len; 
}else{//如果当前页大于左偏移 
//如果当前页码右偏移超出最大分页数 
if($page+$pageoffset>=$pages+1){ 
$init = $pages-$page_len+1; 
}else{ 
//左右偏移都存在时的计算 
$init = $page-$pageoffset; 
$max_p = $page+$pageoffset; 
} 
} 
} 
for($i=$init;$i<=$max_p;$i++){ 
if($i==$page){ 
$key.=' <span>'.$i.'</span>'; 
} else { 
$key.=" <a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">".$i."</a>"; 
} 
} 
if($page!=$pages){ 
$key.=" <a href=\"".$_SERVER['PHP_SELF']."?page=".($page+1)."\">下一页</a> ";//下一页 
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page={$pages}\">最后一页</a>"; //最后一页 
}else { 
$key.="下一页 ";//下一页 
$key.="最后一页"; //最后一页 
} 
$key.='</div>'; 
?> 
<tr> 
<td colspan="21" bgcolor="#E0EEE0"><div align="center"><?php echo $key?></div></td> 
</tr> 
</table> 
</body> 
</html> 

